package com.example.text2.mapper;

import com.example.text2.pojo.Coustomer;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface CoustmerMapper {
    @Select("select * from t_customer where id=#{id}")
    public Coustomer findById(Integer id);
    @Select("select * from t_customer")
    public List<Coustomer> findAll();
    @Select("select * from t_customer where username=#{username} and jobs = #{jobs}")
    List<Coustomer> search(Coustomer coustomer);
}
